Overview

Brought to you by YData

Dataset statistics

Number of variables	49
Number of observations	7381
Missing cells	195949
Missing cells (%)	54.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.7 MiB
Average record size in memory	384.0 B

Variable types

Text	8
Numeric	14
DateTime	6
Boolean	5
Categorical	16

Alerts

`preventTargetGapPoints` has constant value "True"	Constant
`userFlaggedNewItem` has constant value "True"	Constant
`pointsNotAwardedReason` has constant value "Action not allowed for user and CPG"	Constant
`deleted` has constant value "True"	Constant
`competitiveProduct` is highly overall correlated with `competitorRewardsGroup` and 16 other fields	High correlation
`competitorRewardsGroup` is highly overall correlated with `competitiveProduct` and 8 other fields	High correlation
`discountedItemPrice` is highly overall correlated with `competitiveProduct` and 9 other fields	High correlation
`finalPrice` is highly overall correlated with `competitiveProduct` and 18 other fields	High correlation
`hours_diff` is highly overall correlated with `competitorRewardsGroup` and 12 other fields	High correlation
`itemNumber` is highly overall correlated with `competitiveProduct` and 18 other fields	High correlation
`itemPrice` is highly overall correlated with `discountedItemPrice` and 14 other fields	High correlation
`items_in_receipt_list` is highly overall correlated with `hours_diff` and 17 other fields	High correlation
`minutes_diff` is highly overall correlated with `competitorRewardsGroup` and 12 other fields	High correlation
`needsFetchReview` is highly overall correlated with `competitorRewardsGroup` and 16 other fields	High correlation
`needsFetchReviewReason` is highly overall correlated with `competitiveProduct` and 17 other fields	High correlation
`originalFinalPrice` is highly overall correlated with `competitiveProduct` and 21 other fields	High correlation
`originalMetaBriteBarcode` is highly overall correlated with `competitiveProduct` and 21 other fields	High correlation
`originalMetaBriteDescription` is highly overall correlated with `finalPrice` and 21 other fields	High correlation
`originalMetaBriteItemPrice` is highly overall correlated with `competitiveProduct` and 21 other fields	High correlation
`originalMetaBriteQuantityPurchased` is highly overall correlated with `competitiveProduct` and 21 other fields	High correlation
`partnerItemId` is highly overall correlated with `competitiveProduct` and 14 other fields	High correlation
`pointsEarned` is highly overall correlated with `competitiveProduct` and 18 other fields	High correlation
`pointsPayerId` is highly overall correlated with `finalPrice` and 15 other fields	High correlation
`priceAfterCoupon` is highly overall correlated with `competitiveProduct` and 5 other fields	High correlation
`purchasedItemCount` is highly overall correlated with `hours_diff` and 17 other fields	High correlation
`quantityPurchased` is highly overall correlated with `itemNumber` and 7 other fields	High correlation
`rewardsProductPartnerId` is highly overall correlated with `competitiveProduct` and 16 other fields	High correlation
`summary_list_difference_count` is highly overall correlated with `competitorRewardsGroup` and 12 other fields	High correlation
`targetPrice` is highly overall correlated with `competitiveProduct` and 21 other fields	High correlation
`total_receipt_points_earned` is highly overall correlated with `hours_diff` and 11 other fields	High correlation
`total_receipt_spent` is highly overall correlated with `hours_diff` and 17 other fields	High correlation
`userFlaggedBarcode` is highly overall correlated with `competitiveProduct` and 21 other fields	High correlation
`userFlaggedDescription` is highly overall correlated with `finalPrice` and 17 other fields	High correlation
`userFlaggedPrice` is highly overall correlated with `competitiveProduct` and 19 other fields	High correlation
`userFlaggedQuantity` is highly overall correlated with `competitiveProduct` and 17 other fields	High correlation
`needsFetchReviewReason` is highly imbalanced (77.4%)	Imbalance
`purchasedItemCount` has 484 (6.6%) missing values	Missing
`finisheddate` has 1411 (19.1%) missing values	Missing
`pointsawardeddate` has 1301 (17.6%) missing values	Missing
`purchasedate` has 458 (6.2%) missing values	Missing
`total_receipt_points_earned` has 1128 (15.3%) missing values	Missing
`total_receipt_spent` has 435 (5.9%) missing values	Missing
`barcode` has 4291 (58.1%) missing values	Missing
`description` has 821 (11.1%) missing values	Missing
`finalPrice` has 614 (8.3%) missing values	Missing
`itemPrice` has 614 (8.3%) missing values	Missing
`needsFetchReview` has 6568 (89.0%) missing values	Missing
`partnerItemId` has 440 (6.0%) missing values	Missing
`preventTargetGapPoints` has 7023 (95.1%) missing values	Missing
`quantityPurchased` has 614 (8.3%) missing values	Missing
`userFlaggedBarcode` has 7044 (95.4%) missing values	Missing
`userFlaggedNewItem` has 7058 (95.6%) missing values	Missing
`userFlaggedPrice` has 7082 (95.9%) missing values	Missing
`userFlaggedQuantity` has 7082 (95.9%) missing values	Missing
`needsFetchReviewReason` has 7162 (97.0%) missing values	Missing
`pointsNotAwardedReason` has 7041 (95.4%) missing values	Missing
`pointsPayerId` has 6114 (82.8%) missing values	Missing
`rewardsGroup` has 5650 (76.5%) missing values	Missing
`rewardsProductPartnerId` has 5112 (69.3%) missing values	Missing
`userFlaggedDescription` has 7176 (97.2%) missing values	Missing
`originalMetaBriteBarcode` has 7310 (99.0%) missing values	Missing
`originalMetaBriteDescription` has 7371 (99.9%) missing values	Missing
`brandCode` has 4781 (64.8%) missing values	Missing
`competitorRewardsGroup` has 7106 (96.3%) missing values	Missing
`discountedItemPrice` has 1612 (21.8%) missing values	Missing
`originalReceiptItemText` has 1621 (22.0%) missing values	Missing
`itemNumber` has 7228 (97.9%) missing values	Missing
`originalMetaBriteQuantityPurchased` has 7366 (99.8%) missing values	Missing
`pointsEarned` has 6454 (87.4%) missing values	Missing
`targetPrice` has 7003 (94.9%) missing values	Missing
`competitiveProduct` has 6736 (91.3%) missing values	Missing
`originalFinalPrice` has 7372 (99.9%) missing values	Missing
`originalMetaBriteItemPrice` has 7372 (99.9%) missing values	Missing
`deleted` has 7372 (99.9%) missing values	Missing
`priceAfterCoupon` has 6425 (87.0%) missing values	Missing
`metabriteCampaignId` has 6518 (88.3%) missing values	Missing
`items_in_receipt_list` has 464 (6.3%) missing values	Missing
`summary_list_difference_count` has 513 (7.0%) missing values	Missing
`hours_diff` has 1301 (17.6%) missing values	Missing
`minutes_diff` has 1301 (17.6%) missing values	Missing
`receipt_item_id` has unique values	Unique
`partnerItemId` has 145 (2.0%) zeros	Zeros
`summary_list_difference_count` has 6756 (91.5%) zeros	Zeros
`hours_diff` has 439 (5.9%) zeros	Zeros
`minutes_diff` has 439 (5.9%) zeros	Zeros

Reproduction

Analysis started	2025-02-04 04:56:57.447466
Analysis finished	2025-02-04 05:02:01.983846
Duration	5 minutes and 4.54 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

receipt_id
Text

Distinct	1119
Distinct (%)	15.2%
Missing	0
Missing (%)	0.0%
Memory size	57.8 KiB

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	177144
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	817 ?
Unique (%)	11.1%

Sample

1st row	5ff1e1cd0a720f052300056f
2nd row	5ff5d1f20a720f05230005db
3rd row	5ff5d1f20a720f05230005db
4th row	5ff5d1f20a720f05230005db
5th row	5ff5d1f20a720f05230005db

Value	Count	Frequency (%)
600f2fc80a720f0535000030	459	6.2%
600f39c30a7214ada2000030	450	6.1%
600f24970a720f053500002f	381	5.2%
600f0cc70a720f053500002c	217	2.9%
600a1a8d0a7214ada2000008	203	2.8%
60049d9d0a720f05f3000094	194	2.6%
60025cb80a720f05f300008d	185	2.5%
600260210a720f05f300008f	183	2.5%
600a1e270a720f0535000009	176	2.4%
600edb570a720f053500001d	155	2.1%
Other values (1109)	4778	64.7%

Most occurring characters

Value	Count	Frequency (%)
0	62005	35.0%
a	15529	8.8%
2	14350	8.1%
f	11783	6.7%
7	10142	5.7%
5	9317	5.3%
6	8434	4.8%
3	8155	4.6%
1	6774	3.8%
4	6027	3.4%
Other values (6)	24628	13.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	177144	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	62005	35.0%
a	15529	8.8%
2	14350	8.1%
f	11783	6.7%
7	10142	5.7%
5	9317	5.3%
6	8434	4.8%
3	8155	4.6%
1	6774	3.8%
4	6027	3.4%
Other values (6)	24628	13.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	177144	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	62005	35.0%
a	15529	8.8%
2	14350	8.1%
f	11783	6.7%
7	10142	5.7%
5	9317	5.3%
6	8434	4.8%
3	8155	4.6%
1	6774	3.8%
4	6027	3.4%
Other values (6)	24628	13.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	177144	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	62005	35.0%
a	15529	8.8%
2	14350	8.1%
f	11783	6.7%
7	10142	5.7%
5	9317	5.3%
6	8434	4.8%
3	8155	4.6%
1	6774	3.8%
4	6027	3.4%
Other values (6)	24628	13.9%

purchasedItemCount
Real number (ℝ)

High correlation Missing

Distinct	50
Distinct (%)	0.7%
Missing	484
Missing (%)	6.6%
Infinite	0
Infinite (%)	0.0%
Mean	240.76468

Minimum	0
Maximum	689
Zeros	25
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	93
median	167
Q3	335
95-th percentile	689
Maximum	689
Range	689
Interquartile range (IQR)	242

Descriptive statistics

Standard deviation	221.80545
Coefficient of variation (CV)	0.92125412
Kurtosis	-0.29312694
Mean	240.76468
Median Absolute Deviation (MAD)	136
Skewness	0.96073798
Sum	1660554
Variance	49197.659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
689	459	6.2%
670	450	6.1%
599	381	5.2%
5	370	5.0%
1	325	4.4%
133	248	3.4%
303	217	2.9%
2	212	2.9%
214	203	2.8%
212	194	2.6%
Other values (40)	3838	52.0%
(Missing)	484	6.6%

Value	Count	Frequency (%)
0	25	0.3%
1	325	4.4%
2	212	2.9%
3	32	0.4%
4	157	2.1%
5	370	5.0%
6	23	0.3%
7	15	0.2%
8	2	< 0.1%
9	90	1.2%

Value	Count	Frequency (%)
689	459	6.2%
670	450	6.1%
599	381	5.2%
348	127	1.7%
341	124	1.7%
335	185	2.5%
309	183	2.5%
303	217	2.9%
240	148	2.0%
229	99	1.3%

createdate
Date

Distinct	1107
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Memory size	57.8 KiB

Minimum	2020-10-30 20:17:59
Maximum	2021-03-01 23:17:34.772000
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

datescanned
Date

Distinct	1107
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Memory size	57.8 KiB

Minimum	2020-10-30 20:17:59
Maximum	2021-03-01 23:17:34.772000
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

finisheddate
Date

Missing

Distinct	553
Distinct (%)	9.3%
Missing	1411
Missing (%)	19.1%
Memory size	57.8 KiB

Minimum	2021-01-03 15:24:10
Maximum	2021-02-26 22:36:25
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

modifydate
Date

Distinct	1104
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Memory size	57.8 KiB

Minimum	2021-01-03 15:24:10
Maximum	2021-03-01 23:17:34.772000
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

pointsawardeddate
Date

Missing

Distinct	523
Distinct (%)	8.6%
Missing	1301
Missing (%)	17.6%
Memory size	57.8 KiB

Minimum	2020-10-30 20:18:00
Maximum	2021-02-26 22:36:25
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

purchasedate
Date

Missing

Distinct	358
Distinct (%)	5.2%
Missing	458
Missing (%)	6.2%
Memory size	57.8 KiB

Minimum	2017-10-30 00:00:00
Maximum	2021-03-08 17:37:13
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

total_receipt_points_earned
Real number (ℝ)

High correlation Missing

Distinct	119
Distinct (%)	1.9%
Missing	1128
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%
Mean	2175.5837

Minimum	0
Maximum	10199.8
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	29.0 KiB

Quantile statistics

Minimum	0
5-th percentile	25
Q1	750
median	1447
Q3	2685.8
95-th percentile	7137.2002
Maximum	10199.8
Range	10199.8
Interquartile range (IQR)	1935.8

Descriptive statistics

Standard deviation	2175.7334
Coefficient of variation (CV)	1.0000688
Kurtosis	0.76142293
Mean	2175.5837
Median Absolute Deviation (MAD)	841.29999
Skewness	1.3340405
Sum	13603925
Variance	4733815.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4944.700195	459	6.2%
7137.200195	450	6.1%
750	342	4.6%
5	298	4.0%
1178.699951	203	2.8%
922.0999756	194	2.6%
1658.300049	185	2.5%
3659.399902	183	2.5%
1135.099976	176	2.4%
487.7000122	155	2.1%
Other values (109)	3608	48.9%
(Missing)	1128	15.3%

Value	Count	Frequency (%)
0	6	0.1%
5	298	4.0%
25	104	1.4%
35	7	0.1%
50	27	0.4%
50.59999847	5	0.1%
50.90000153	1	< 0.1%
55	22	0.3%
91.19999695	8	0.1%
94.59999847	5	0.1%

Value	Count	Frequency (%)
10199.7998	2	< 0.1%
9850	1	< 0.1%
9449.799805	11	0.1%
9200	10	0.1%
8950	10	0.1%
8850	10	0.1%
8700	30	0.4%
7137.200195	450	6.1%
6257.299805	127	1.7%
5850	2	< 0.1%

total_receipt_spent
Real number (ℝ)

High correlation Missing

Distinct	94
Distinct (%)	1.4%
Missing	435
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	1368.5772

Minimum	0
Maximum	4721.9502
Zeros	25
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	29.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	373.54999
median	776.78998
Q3	1183.1
95-th percentile	4721.9502
Maximum	4721.9502
Range	4721.9502
Interquartile range (IQR)	809.54999

Descriptive statistics

Standard deviation	1588.9594
Coefficient of variation (CV)	1.1610301
Kurtosis	0.20020902
Mean	1368.5772
Median Absolute Deviation (MAD)	406.31
Skewness	1.3484646
Sum	9506137.3
Variance	2524791.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4566.169922	459	6.2%
4721.950195	450	6.1%
4368.799805	381	5.2%
1	324	4.4%
2084.820068	217	2.9%
49.95000076	215	2.9%
1183.099976	203	2.8%
743.789978	194	2.6%
1177.839966	185	2.5%
1043.180054	183	2.5%
Other values (84)	4135	56.0%
(Missing)	435	5.9%

Value	Count	Frequency (%)
0	25	0.3%
0.1599999964	1	< 0.1%
0.9900000095	7	0.1%
1	324	4.4%
2	8	0.1%
2.230000019	7	0.1%
2.289999962	1	< 0.1%
2.99000001	1	< 0.1%
3	18	0.2%
3.089999914	5	0.1%

Value	Count	Frequency (%)
4721.950195	450	6.1%
4566.169922	459	6.2%
4368.799805	381	5.2%
2084.820068	217	2.9%
1198.680054	127	1.7%
1183.099976	203	2.8%
1177.839966	185	2.5%
1107.819946	125	1.7%
1083.23999	124	1.7%
1043.180054	183	2.5%

barcode
Text

Missing

Distinct	568
Distinct (%)	18.4%
Missing	4291
Missing (%)	58.1%
Memory size	57.8 KiB

Length

Max length	13
Median length	12
Mean length	11.067314
Min length	2

Characters and Unicode

Total characters	34198
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	261 ?
Unique (%)	8.4%

Sample

1st row	021000051113
2nd row	021000051113
3rd row	021000051113
4th row	021000051113
5th row	043000204399

Value	Count	Frequency (%)
4011	177	5.7%
036000320893	92	3.0%
034100573065	90	2.9%
036000391718	87	2.8%
012000809941	76	2.5%
076840580750	63	2.0%
041000022623	54	1.7%
076840100354	53	1.7%
028400642033	45	1.5%
311111511867	41	1.3%
Other values (558)	2312	74.8%

Most occurring characters

Value	Count	Frequency (%)
0	11212	32.8%
1	4353	12.7%
4	3087	9.0%
3	2690	7.9%
2	2582	7.6%
5	2310	6.8%
7	2083	6.1%
6	2026	5.9%
8	1890	5.5%
9	1471	4.3%
Other values (14)	494	1.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34198	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	11212	32.8%
1	4353	12.7%
4	3087	9.0%
3	2690	7.9%
2	2582	7.6%
5	2310	6.8%
7	2083	6.1%
6	2026	5.9%
8	1890	5.5%
9	1471	4.3%
Other values (14)	494	1.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34198	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	11212	32.8%
1	4353	12.7%
4	3087	9.0%
3	2690	7.9%
2	2582	7.6%
5	2310	6.8%
7	2083	6.1%
6	2026	5.9%
8	1890	5.5%
9	1471	4.3%
Other values (14)	494	1.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34198	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	11212	32.8%
1	4353	12.7%
4	3087	9.0%
3	2690	7.9%
2	2582	7.6%
5	2310	6.8%
7	2083	6.1%
6	2026	5.9%
8	1890	5.5%
9	1471	4.3%
Other values (14)	494	1.4%

description
Text

Missing

Distinct	1889
Distinct (%)	28.8%
Missing	821
Missing (%)	11.1%
Memory size	57.8 KiB

Length

Max length	155
Median length	92
Mean length	29.15122
Min length	2

Characters and Unicode

Total characters	191232
Distinct characters	83
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1136 ?
Unique (%)	17.3%

Sample

1st row	MSSN TORTLLA
2nd row	Jell-O Instant Pudding & Pie Filling French Vanilla, 3.4 Oz
3rd row	ITEM NOT FOUND
4th row	VASELINE COCOA BUTTER SKIN MOISTURIZER LOTION CONDITIONING RP 34.5 OZ
5th row	ITEM NOT FOUND

Value	Count	Frequency (%)
oz	1209	3.5%
	931	2.7%
cheese	327	1.0%
12	321	0.9%
bag	276	0.8%
hyv	246	0.7%
can	241	0.7%
ct	237	0.7%
regular	215	0.6%
fl	211	0.6%
Other values (3183)	30149	87.7%

Most occurring characters

Value	Count	Frequency (%)
	27810	14.5%
E	8222	4.3%
e	7865	4.1%
R	7158	3.7%
C	6724	3.5%
S	6612	3.5%
A	6575	3.4%
L	6297	3.3%
O	6266	3.3%
N	5520	2.9%
Other values (73)	102183	53.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	191232	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	27810	14.5%
E	8222	4.3%
e	7865	4.1%
R	7158	3.7%
C	6724	3.5%
S	6612	3.5%
A	6575	3.4%
L	6297	3.3%
O	6266	3.3%
N	5520	2.9%
Other values (73)	102183	53.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	191232	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	27810	14.5%
E	8222	4.3%
e	7865	4.1%
R	7158	3.7%
C	6724	3.5%
S	6612	3.5%
A	6575	3.4%
L	6297	3.3%
O	6266	3.3%
N	5520	2.9%
Other values (73)	102183	53.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	191232	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	27810	14.5%
E	8222	4.3%
e	7865	4.1%
R	7158	3.7%
C	6724	3.5%
S	6612	3.5%
A	6575	3.4%
L	6297	3.3%
O	6266	3.3%
N	5520	2.9%
Other values (73)	102183	53.4%

finalPrice
Real number (ℝ)

High correlation Missing

Distinct	823
Distinct (%)	12.2%
Missing	614
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	7.871661

Minimum	0
Maximum	441.58
Zeros	4
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.56
Q1	2.29
median	4.28
Q3	9.99
95-th percentile	26
Maximum	441.58
Range	441.58
Interquartile range (IQR)	7.7

Descriptive statistics

Standard deviation	14.656776
Coefficient of variation (CV)	1.8619674
Kurtosis	207.38946
Mean	7.871661
Median Absolute Deviation (MAD)	2.7
Skewness	11.383034
Sum	53267.53
Variance	214.82108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	375	5.1%
9.99	355	4.8%
3.99	243	3.3%
4.99	195	2.6%
0.56	190	2.6%
2.99	179	2.4%
5.99	176	2.4%
3.49	139	1.9%
2.34	134	1.8%
5	124	1.7%
Other values (813)	4657	63.1%
(Missing)	614	8.3%

Value	Count	Frequency (%)
0	4	0.1%
0.16	1	< 0.1%
0.19	13	0.2%
0.25	2	< 0.1%
0.32	2	< 0.1%
0.48	3	< 0.1%
0.5	76	1.0%
0.54	66	0.9%
0.55	2	< 0.1%
0.56	190	2.6%

Value	Count	Frequency (%)
441.58	1	< 0.1%
245	3	< 0.1%
223.36	5	0.1%
180	6	0.1%
168.84	5	0.1%
115.96	1	< 0.1%
100.48	1	< 0.1%
100	6	0.1%
95.84	4	0.1%
82.34	1	< 0.1%

itemPrice
Real number (ℝ)

High correlation Missing

Distinct	823
Distinct (%)	12.2%
Missing	614
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	7.8721782

Minimum	0
Maximum	441.58
Zeros	4
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.56
Q1	2.29
median	4.28
Q3	9.99
95-th percentile	26
Maximum	441.58
Range	441.58
Interquartile range (IQR)	7.7

Descriptive statistics

Standard deviation	14.656623
Coefficient of variation (CV)	1.8618256
Kurtosis	207.39662
Mean	7.8721782
Median Absolute Deviation (MAD)	2.7
Skewness	11.383294
Sum	53271.03
Variance	214.8166
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	375	5.1%
9.99	355	4.8%
3.99	243	3.3%
4.99	196	2.7%
0.56	190	2.6%
2.99	180	2.4%
5.99	176	2.4%
3.49	139	1.9%
2.34	134	1.8%
5	124	1.7%
Other values (813)	4655	63.1%
(Missing)	614	8.3%

Value	Count	Frequency (%)
0	4	0.1%
0.16	1	< 0.1%
0.19	13	0.2%
0.25	2	< 0.1%
0.32	2	< 0.1%
0.48	3	< 0.1%
0.5	76	1.0%
0.54	66	0.9%
0.55	2	< 0.1%
0.56	190	2.6%

Value	Count	Frequency (%)
441.58	1	< 0.1%
245	3	< 0.1%
223.36	5	0.1%
180	6	0.1%
168.84	5	0.1%
115.96	1	< 0.1%
100.48	1	< 0.1%
100	6	0.1%
95.84	4	0.1%
82.34	1	< 0.1%

needsFetchReview
Boolean

High correlation Missing

Distinct	2
Distinct (%)	0.2%
Missing	6568
Missing (%)	89.0%
Memory size	57.8 KiB

False	594
True	219
(Missing)	6568

Value	Count	Frequency (%)
False	594	8.0%
True	219	3.0%
(Missing)	6568	89.0%

partnerItemId
Real number (ℝ)

High correlation Missing Zeros

Distinct	916
Distinct (%)	13.2%
Missing	440
Missing (%)	6.0%
Infinite	0
Infinite (%)	0.0%
Mean	988.52428

Minimum	0
Maximum	2043
Zeros	145
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1027
median	1143
Q3	1274
95-th percentile	1644
Maximum	2043
Range	2043
Interquartile range (IQR)	247

Descriptive statistics

Standard deviation	527.38082
Coefficient of variation (CV)	0.53350316
Kurtosis	-0.13640789
Mean	988.52428
Median Absolute Deviation (MAD)	123
Skewness	-1.0174858
Sum	6861347
Variance	278130.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	531	7.2%
2	203	2.8%
0	145	2.0%
3	135	1.8%
4	113	1.5%
5	106	1.4%
7	34	0.5%
8	34	0.5%
6	34	0.5%
9	34	0.5%
Other values (906)	5572	75.5%
(Missing)	440	6.0%

Value	Count	Frequency (%)
0	145	2.0%
1	531	7.2%
2	203	2.8%
3	135	1.8%
4	113	1.5%
5	106	1.4%
6	34	0.5%
7	34	0.5%
8	34	0.5%
9	34	0.5%

Value	Count	Frequency (%)
2043	1	< 0.1%
2040	1	< 0.1%
2036	1	< 0.1%
2033	1	< 0.1%
2029	1	< 0.1%
2026	1	< 0.1%
1986	1	< 0.1%
1983	1	< 0.1%
1980	1	< 0.1%
1976	1	< 0.1%

preventTargetGapPoints
Boolean

Constant Missing

Distinct	1
Distinct (%)	0.3%
Missing	7023
Missing (%)	95.1%
Memory size	57.8 KiB

True	358
(Missing)	7023

Value	Count	Frequency (%)
True	358	4.9%
(Missing)	7023	95.1%

quantityPurchased
Real number (ℝ)

High correlation Missing

Distinct	13
Distinct (%)	0.2%
Missing	614
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.3861386

Minimum	1
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	4
Maximum	17
Range	16
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.2043632
Coefficient of variation (CV)	0.86886201
Kurtosis	36.002117
Mean	1.3861386
Median Absolute Deviation (MAD)	0
Skewness	5.1137362
Sum	9380
Variance	1.4504907
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1	5628	76.2%
2	622	8.4%
4	170	2.3%
3	134	1.8%
5	101	1.4%
6	37	0.5%
8	22	0.3%
10	15	0.2%
7	13	0.2%
9	13	0.2%
Other values (3)	12	0.2%
(Missing)	614	8.3%

Value	Count	Frequency (%)
1	5628	76.2%
2	622	8.4%
3	134	1.8%
4	170	2.3%
5	101	1.4%
6	37	0.5%
7	13	0.2%
8	22	0.3%
9	13	0.2%
10	15	0.2%

Value	Count	Frequency (%)
17	3	< 0.1%
14	3	< 0.1%
12	6	0.1%
10	15	0.2%
9	13	0.2%
8	22	0.3%
7	13	0.2%
6	37	0.5%
5	101	1.4%
4	170	2.3%

userFlaggedBarcode
Categorical

High correlation Missing

Distinct	6
Distinct (%)	1.8%
Missing	7044
Missing (%)	95.4%
Memory size	57.8 KiB

034100573065	166
4011	107
1234	32
028400642255	13
079400066619	10

Length

Max length	12
Median length	12
Mean length	8.7002967
Min length	4

Characters and Unicode

Total characters	2932
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1234
2nd row	034100573065
3rd row	034100573065
4th row	034100573065
5th row	034100573065

Common Values

Value	Count	Frequency (%)
034100573065	166	2.2%
4011	107	1.4%
1234	32	0.4%
028400642255	13	0.2%
079400066619	10	0.1%
075925306254	9	0.1%
(Missing)	7044	95.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
034100573065	166	49.3%
4011	107	31.8%
1234	32	9.5%
028400642255	13	3.9%
079400066619	10	3.0%
075925306254	9	2.7%

Most occurring characters

Value	Count	Frequency (%)
0	868	29.6%
1	422	14.4%
5	385	13.1%
3	373	12.7%
4	350	11.9%
6	218	7.4%
7	185	6.3%
2	89	3.0%
9	29	1.0%
8	13	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2932	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	868	29.6%
1	422	14.4%
5	385	13.1%
3	373	12.7%
4	350	11.9%
6	218	7.4%
7	185	6.3%
2	89	3.0%
9	29	1.0%
8	13	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2932	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	868	29.6%
1	422	14.4%
5	385	13.1%
3	373	12.7%
4	350	11.9%
6	218	7.4%
7	185	6.3%
2	89	3.0%
9	29	1.0%
8	13	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2932	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	868	29.6%
1	422	14.4%
5	385	13.1%
3	373	12.7%
4	350	11.9%
6	218	7.4%
7	185	6.3%
2	89	3.0%
9	29	1.0%
8	13	0.4%

userFlaggedNewItem
Boolean

Constant Missing

Distinct	1
Distinct (%)	0.3%
Missing	7058
Missing (%)	95.6%
Memory size	57.8 KiB

True	323
(Missing)	7058

Value	Count	Frequency (%)
True	323	4.4%
(Missing)	7058	95.6%

userFlaggedPrice
Categorical

High correlation Missing

Distinct	13
Distinct (%)	4.3%
Missing	7082
Missing (%)	95.9%
Memory size	57.8 KiB

29.00	142
1.00	26
10.00	22
28.00	15
21.00	14
Other values (8)	80

Length

Max length	5
Median length	5
Mean length	4.8862876
Min length	4

Characters and Unicode

Total characters	1461
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	29.00
2nd row	29.00
3rd row	29.00
4th row	29.00
5th row	29.00

Common Values

Value	Count	Frequency (%)
29.00	142	1.9%
1.00	26	0.4%
10.00	22	0.3%
28.00	15	0.2%
21.00	14	0.2%
20.00	14	0.2%
27.00	13	0.2%
25.00	10	0.1%
23.00	10	0.1%
26.00	10	0.1%
Other values (3)	23	0.3%
(Missing)	7082	95.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
29.00	142	47.5%
1.00	26	8.7%
10.00	22	7.4%
28.00	15	5.0%
21.00	14	4.7%
20.00	14	4.7%
27.00	13	4.3%
25.00	10	3.3%
23.00	10	3.3%
26.00	10	3.3%
Other values (3)	23	7.7%

Most occurring characters

Value	Count	Frequency (%)
0	618	42.3%
.	299	20.5%
2	260	17.8%
9	142	9.7%
1	62	4.2%
5	18	1.2%
6	18	1.2%
8	15	1.0%
7	13	0.9%
3	10	0.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1461	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	618	42.3%
.	299	20.5%
2	260	17.8%
9	142	9.7%
1	62	4.2%
5	18	1.2%
6	18	1.2%
8	15	1.0%
7	13	0.9%
3	10	0.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1461	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	618	42.3%
.	299	20.5%
2	260	17.8%
9	142	9.7%
1	62	4.2%
5	18	1.2%
6	18	1.2%
8	15	1.0%
7	13	0.9%
3	10	0.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1461	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	618	42.3%
.	299	20.5%
2	260	17.8%
9	142	9.7%
1	62	4.2%
5	18	1.2%
6	18	1.2%
8	15	1.0%
7	13	0.9%
3	10	0.7%

userFlaggedQuantity
Categorical

High correlation Missing

Distinct	5
Distinct (%)	1.7%
Missing	7082
Missing (%)	95.9%
Memory size	57.8 KiB

1.0	189
3.0	31
4.0	30
2.0	29
5.0	20

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	897
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	189	2.6%
3.0	31	0.4%
4.0	30	0.4%
2.0	29	0.4%
5.0	20	0.3%
(Missing)	7082	95.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	189	63.2%
3.0	31	10.4%
4.0	30	10.0%
2.0	29	9.7%
5.0	20	6.7%

Most occurring characters

Value	Count	Frequency (%)
.	299	33.3%
0	299	33.3%
1	189	21.1%
3	31	3.5%
4	30	3.3%
2	29	3.2%
5	20	2.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	897	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	299	33.3%
0	299	33.3%
1	189	21.1%
3	31	3.5%
4	30	3.3%
2	29	3.2%
5	20	2.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	897	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	299	33.3%
0	299	33.3%
1	189	21.1%
3	31	3.5%
4	30	3.3%
2	29	3.2%
5	20	2.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	897	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	299	33.3%
0	299	33.3%
1	189	21.1%
3	31	3.5%
4	30	3.3%
2	29	3.2%
5	20	2.2%

needsFetchReviewReason
Categorical

High correlation Imbalance Missing

Distinct	2
Distinct (%)	0.9%
Missing	7162
Missing (%)	97.0%
Memory size	57.8 KiB

USER_FLAGGED	211
POINTS_GREATER_THAN_THRESHOLD	8

Length

Max length	29
Median length	12
Mean length	12.621005
Min length	12

Characters and Unicode

Total characters	2764
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USER_FLAGGED
2nd row	USER_FLAGGED
3rd row	USER_FLAGGED
4th row	USER_FLAGGED
5th row	USER_FLAGGED

Common Values

Value	Count	Frequency (%)
USER_FLAGGED	211	2.9%
POINTS_GREATER_THAN_THRESHOLD	8	0.1%
(Missing)	7162	97.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
user_flagged	211	96.3%
points_greater_than_threshold	8	3.7%

Most occurring characters

Value	Count	Frequency (%)
E	446	16.1%
G	430	15.6%
R	235	8.5%
_	235	8.5%
S	227	8.2%
A	227	8.2%
L	219	7.9%
D	219	7.9%
U	211	7.6%
F	211	7.6%
Other values (6)	104	3.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2764	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	446	16.1%
G	430	15.6%
R	235	8.5%
_	235	8.5%
S	227	8.2%
A	227	8.2%
L	219	7.9%
D	219	7.9%
U	211	7.6%
F	211	7.6%
Other values (6)	104	3.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2764	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	446	16.1%
G	430	15.6%
R	235	8.5%
_	235	8.5%
S	227	8.2%
A	227	8.2%
L	219	7.9%
D	219	7.9%
U	211	7.6%
F	211	7.6%
Other values (6)	104	3.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2764	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	446	16.1%
G	430	15.6%
R	235	8.5%
_	235	8.5%
S	227	8.2%
A	227	8.2%
L	219	7.9%
D	219	7.9%
U	211	7.6%
F	211	7.6%
Other values (6)	104	3.8%

pointsNotAwardedReason
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.3%
Missing	7041
Missing (%)	95.4%
Memory size	57.8 KiB

Action not allowed for user and CPG	340

Length

Max length	35
Median length	35
Mean length	35
Min length	35

Characters and Unicode

Total characters	11900
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Action not allowed for user and CPG
2nd row	Action not allowed for user and CPG
3rd row	Action not allowed for user and CPG
4th row	Action not allowed for user and CPG
5th row	Action not allowed for user and CPG

Common Values

Value	Count	Frequency (%)
Action not allowed for user and CPG	340	4.6%
(Missing)	7041	95.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
action	340	14.3%
not	340	14.3%
allowed	340	14.3%
for	340	14.3%
user	340	14.3%
and	340	14.3%
cpg	340	14.3%

Most occurring characters

Value	Count	Frequency (%)
	2040	17.1%
o	1360	11.4%
n	1020	8.6%
t	680	5.7%
a	680	5.7%
l	680	5.7%
e	680	5.7%
d	680	5.7%
r	680	5.7%
A	340	2.9%
Other values (9)	3060	25.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11900	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	2040	17.1%
o	1360	11.4%
n	1020	8.6%
t	680	5.7%
a	680	5.7%
l	680	5.7%
e	680	5.7%
d	680	5.7%
r	680	5.7%
A	340	2.9%
Other values (9)	3060	25.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11900	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	2040	17.1%
o	1360	11.4%
n	1020	8.6%
t	680	5.7%
a	680	5.7%
l	680	5.7%
e	680	5.7%
d	680	5.7%
r	680	5.7%
A	340	2.9%
Other values (9)	3060	25.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11900	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	2040	17.1%
o	1360	11.4%
n	1020	8.6%
t	680	5.7%
a	680	5.7%
l	680	5.7%
e	680	5.7%
d	680	5.7%
r	680	5.7%
A	340	2.9%
Other values (9)	3060	25.7%

pointsPayerId
Categorical

High correlation Missing

Distinct	15
Distinct (%)	1.2%
Missing	6114
Missing (%)	82.8%
Memory size	57.8 KiB

559c2234e4b06aca36af13c6	331
5332f5f6e4b03c9a25efd0b4	281
5332f5fbe4b03c9a25efd0ba	230
550b2565e4b001d5e9e4146f	190
5332f709e4b03c9a25efd0f1	90
Other values (10)	145

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	30408
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	0.3%

Sample

1st row	5332f5f6e4b03c9a25efd0b4
2nd row	5332f5f3e4b03c9a25efd0ae
3rd row	5332f5f6e4b03c9a25efd0b4
4th row	5332f5fbe4b03c9a25efd0ba
5th row	5332f5fbe4b03c9a25efd0ba

Common Values

Value	Count	Frequency (%)
559c2234e4b06aca36af13c6	331	4.5%
5332f5f6e4b03c9a25efd0b4	281	3.8%
5332f5fbe4b03c9a25efd0ba	230	3.1%
550b2565e4b001d5e9e4146f	190	2.6%
5332f709e4b03c9a25efd0f1	90	1.2%
5332f5f3e4b03c9a25efd0ae	56	0.8%
5a734034e4b0d58f376be874	31	0.4%
5e825d64f221c312e698a62a	25	0.3%
5eebc5412455c97a877ef382	24	0.3%
53e10d6368abd3c7065097cc	3	< 0.1%
Other values (5)	6	0.1%
(Missing)	6114	82.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
559c2234e4b06aca36af13c6	331	26.1%
5332f5f6e4b03c9a25efd0b4	281	22.2%
5332f5fbe4b03c9a25efd0ba	230	18.2%
550b2565e4b001d5e9e4146f	190	15.0%
5332f709e4b03c9a25efd0f1	90	7.1%
5332f5f3e4b03c9a25efd0ae	56	4.4%
5a734034e4b0d58f376be874	31	2.4%
5e825d64f221c312e698a62a	25	2.0%
5eebc5412455c97a877ef382	24	1.9%
53e10d6368abd3c7065097cc	3	0.2%
Other values (5)	6	0.5%

Most occurring characters

Value	Count	Frequency (%)
5	3716	12.2%
3	3180	10.5%
f	2586	8.5%
e	2470	8.1%
0	2384	7.8%
4	2369	7.8%
2	2352	7.7%
b	2205	7.3%
a	2049	6.7%
6	1780	5.9%
Other values (6)	5317	17.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30408	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	3716	12.2%
3	3180	10.5%
f	2586	8.5%
e	2470	8.1%
0	2384	7.8%
4	2369	7.8%
2	2352	7.7%
b	2205	7.3%
a	2049	6.7%
6	1780	5.9%
Other values (6)	5317	17.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30408	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	3716	12.2%
3	3180	10.5%
f	2586	8.5%
e	2470	8.1%
0	2384	7.8%
4	2369	7.8%
2	2352	7.7%
b	2205	7.3%
a	2049	6.7%
6	1780	5.9%
Other values (6)	5317	17.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30408	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	3716	12.2%
3	3180	10.5%
f	2586	8.5%
e	2470	8.1%
0	2384	7.8%
4	2369	7.8%
2	2352	7.7%
b	2205	7.3%
a	2049	6.7%
6	1780	5.9%
Other values (6)	5317	17.5%

rewardsGroup
Text

Missing

Distinct	182
Distinct (%)	10.5%
Missing	5650
Missing (%)	76.5%
Memory size	57.8 KiB

Length

Max length	66
Median length	45
Mean length	30.23859
Min length	7

Characters and Unicode

Total characters	52343
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	78 ?
Unique (%)	4.5%

Sample

1st row	SARGENTO GRATED PARMESAN CHEESE
2nd row	SARGENTO GRATED PARMESAN CHEESE
3rd row	SARGENTO GRATED PARMESAN CHEESE
4th row	SARGENTO GRATED PARMESAN CHEESE
5th row	VASELINE HAND AND BODY LOTION

Value	Count	Frequency (%)
and	306	3.4%
cheese	296	3.3%
pack	279	3.1%
	249	2.7%
count	221	2.4%
or	215	2.4%
larger	207	2.3%
12	193	2.1%
ice	184	2.0%
cream	184	2.0%
Other values (386)	6768	74.4%

Most occurring characters

Value	Count	Frequency (%)
	7371	14.1%
E	6109	11.7%
A	3592	6.9%
R	3561	6.8%
S	3452	6.6%
I	2772	5.3%
N	2751	5.3%
C	2534	4.8%
O	2388	4.6%
L	2113	4.0%
Other values (36)	15700	30.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	52343	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	7371	14.1%
E	6109	11.7%
A	3592	6.9%
R	3561	6.8%
S	3452	6.6%
I	2772	5.3%
N	2751	5.3%
C	2534	4.8%
O	2388	4.6%
L	2113	4.0%
Other values (36)	15700	30.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	52343	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	7371	14.1%
E	6109	11.7%
A	3592	6.9%
R	3561	6.8%
S	3452	6.6%
I	2772	5.3%
N	2751	5.3%
C	2534	4.8%
O	2388	4.6%
L	2113	4.0%
Other values (36)	15700	30.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	52343	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	7371	14.1%
E	6109	11.7%
A	3592	6.9%
R	3561	6.8%
S	3452	6.6%
I	2772	5.3%
N	2751	5.3%
C	2534	4.8%
O	2388	4.6%
L	2113	4.0%
Other values (36)	15700	30.0%

rewardsProductPartnerId
Categorical

High correlation Missing

Distinct	16
Distinct (%)	0.7%
Missing	5112
Missing (%)	69.3%
Memory size	57.8 KiB

559c2234e4b06aca36af13c6	878
5332f5f6e4b03c9a25efd0b4	315
5332f5fbe4b03c9a25efd0ba	243
550b2565e4b001d5e9e4146f	202
5332f5f3e4b03c9a25efd0ae	181
Other values (11)	450

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	54456
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	5e7cf838f221c312e698a628
2nd row	5e7cf838f221c312e698a628
3rd row	5e7cf838f221c312e698a628
4th row	5e7cf838f221c312e698a628
5th row	559c2234e4b06aca36af13c6

Common Values

Value	Count	Frequency (%)
559c2234e4b06aca36af13c6	878	11.9%
5332f5f6e4b03c9a25efd0b4	315	4.3%
5332f5fbe4b03c9a25efd0ba	243	3.3%
550b2565e4b001d5e9e4146f	202	2.7%
5332f5f3e4b03c9a25efd0ae	181	2.5%
5e7cf838f221c312e698a628	157	2.1%
5e825d64f221c312e698a62a	124	1.7%
5332f709e4b03c9a25efd0f1	92	1.2%
5a734034e4b0d58f376be874	31	0.4%
5eebc5412455c97a877ef382	24	0.3%
Other values (6)	22	0.3%
(Missing)	5112	69.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
559c2234e4b06aca36af13c6	878	38.7%
5332f5f6e4b03c9a25efd0b4	315	13.9%
5332f5fbe4b03c9a25efd0ba	243	10.7%
550b2565e4b001d5e9e4146f	202	8.9%
5332f5f3e4b03c9a25efd0ae	181	8.0%
5e7cf838f221c312e698a628	157	6.9%
5e825d64f221c312e698a62a	124	5.5%
5332f709e4b03c9a25efd0f1	92	4.1%
5a734034e4b0d58f376be874	31	1.4%
5eebc5412455c97a877ef382	24	1.1%
Other values (6)	22	1.0%

Most occurring characters

Value	Count	Frequency (%)
3	5885	10.8%
5	5784	10.6%
2	4971	9.1%
a	4393	8.1%
6	4111	7.5%
f	4093	7.5%
e	4049	7.4%
c	3988	7.3%
4	3824	7.0%
0	3324	6.1%
Other values (6)	10034	18.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54456	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	5885	10.8%
5	5784	10.6%
2	4971	9.1%
a	4393	8.1%
6	4111	7.5%
f	4093	7.5%
e	4049	7.4%
c	3988	7.3%
4	3824	7.0%
0	3324	6.1%
Other values (6)	10034	18.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54456	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	5885	10.8%
5	5784	10.6%
2	4971	9.1%
a	4393	8.1%
6	4111	7.5%
f	4093	7.5%
e	4049	7.4%
c	3988	7.3%
4	3824	7.0%
0	3324	6.1%
Other values (6)	10034	18.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54456	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	5885	10.8%
5	5784	10.6%
2	4971	9.1%
a	4393	8.1%
6	4111	7.5%
f	4093	7.5%
e	4049	7.4%
c	3988	7.3%
4	3824	7.0%
0	3324	6.1%
Other values (6)	10034	18.4%

userFlaggedDescription
Categorical

High correlation Missing

Distinct	3
Distinct (%)	1.5%
Missing	7176
Missing (%)	97.2%
Memory size	57.8 KiB

MILLER LITE 24 PACK 12OZ CAN	147
	51
DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ	7

Length

Max length	60
Median length	28
Mean length	22.126829
Min length	0

Characters and Unicode

Total characters	4536
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row	MILLER LITE 24 PACK 12OZ CAN
3rd row	MILLER LITE 24 PACK 12OZ CAN
4th row	MILLER LITE 24 PACK 12OZ CAN
5th row	MILLER LITE 24 PACK 12OZ CAN

Common Values

Value	Count	Frequency (%)
MILLER LITE 24 PACK 12OZ CAN	147	2.0%
	51	0.7%
DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ	7	0.1%
(Missing)	7176	97.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
miller	147	15.3%
24	147	15.3%
pack	147	15.3%
12oz	147	15.3%
can	147	15.3%
lite	147	15.3%
chili	7	0.7%
1	7	0.7%
bag	7	0.7%
fat	7	0.7%
Other values (7)	49	5.1%

Most occurring characters

Value	Count	Frequency (%)
	805	17.7%
L	462	10.2%
I	336	7.4%
E	322	7.1%
C	322	7.1%
A	315	6.9%
2	294	6.5%
T	182	4.0%
O	175	3.9%
R	168	3.7%
Other values (16)	1155	25.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4536	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	805	17.7%
L	462	10.2%
I	336	7.4%
E	322	7.1%
C	322	7.1%
A	315	6.9%
2	294	6.5%
T	182	4.0%
O	175	3.9%
R	168	3.7%
Other values (16)	1155	25.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4536	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	805	17.7%
L	462	10.2%
I	336	7.4%
E	322	7.1%
C	322	7.1%
A	315	6.9%
2	294	6.5%
T	182	4.0%
O	175	3.9%
R	168	3.7%
Other values (16)	1155	25.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4536	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	805	17.7%
L	462	10.2%
I	336	7.4%
E	322	7.1%
C	322	7.1%
A	315	6.9%
2	294	6.5%
T	182	4.0%
O	175	3.9%
R	168	3.7%
Other values (16)	1155	25.5%

originalMetaBriteBarcode
Categorical

High correlation Missing

Distinct	6
Distinct (%)	8.5%
Missing	7310
Missing (%)	99.0%
Memory size	57.8 KiB

	47
080878042197	10
034100573065	6
028400642255	4
075925306254	3

Length

Max length	12
Median length	0
Mean length	4.056338
Min length	0

Characters and Unicode

Total characters	288
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	1.4%

Sample

1st row	028400642255
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	47	0.6%
080878042197	10	0.1%
034100573065	6	0.1%
028400642255	4	0.1%
075925306254	3	< 0.1%
002900001903	1	< 0.1%
(Missing)	7310	99.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
080878042197	10	41.7%
034100573065	6	25.0%
028400642255	4	16.7%
075925306254	3	12.5%
002900001903	1	4.2%

Most occurring characters

Value	Count	Frequency (%)
0	79	27.4%
8	34	11.8%
7	29	10.1%
2	29	10.1%
5	29	10.1%
4	27	9.4%
1	17	5.9%
3	16	5.6%
9	15	5.2%
6	13	4.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	288	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	79	27.4%
8	34	11.8%
7	29	10.1%
2	29	10.1%
5	29	10.1%
4	27	9.4%
1	17	5.9%
3	16	5.6%
9	15	5.2%
6	13	4.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	288	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	79	27.4%
8	34	11.8%
7	29	10.1%
2	29	10.1%
5	29	10.1%
4	27	9.4%
1	17	5.9%
3	16	5.6%
9	15	5.2%
6	13	4.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	288	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	79	27.4%
8	34	11.8%
7	29	10.1%
2	29	10.1%
5	29	10.1%
4	27	9.4%
1	17	5.9%
3	16	5.6%
9	15	5.2%
6	13	4.5%

originalMetaBriteDescription
Categorical

High correlation Missing

Distinct	2
Distinct (%)	20.0%
Missing	7371
Missing (%)	99.9%
Memory size	57.8 KiB

MILLER LITE 24 PACK 12OZ CAN	6
DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ	4

Length

Max length	60
Median length	28
Mean length	40.8
Min length	28

Characters and Unicode

Total characters	408
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ
2nd row	MILLER LITE 24 PACK 12OZ CAN
3rd row	MILLER LITE 24 PACK 12OZ CAN
4th row	DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ
5th row	DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ

Common Values

Value	Count	Frequency (%)
MILLER LITE 24 PACK 12OZ CAN	6	0.1%
DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ	4	0.1%
(Missing)	7371	99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
miller	6	7.5%
24	6	7.5%
pack	6	7.5%
12oz	6	7.5%
can	6	7.5%
lite	6	7.5%
chili	4	5.0%
1	4	5.0%
bag	4	5.0%
fat	4	5.0%
Other values (7)	28	35.0%

Most occurring characters

Value	Count	Frequency (%)
	70	17.2%
I	36	8.8%
L	30	7.4%
E	28	6.9%
C	28	6.9%
T	26	6.4%
A	24	5.9%
O	22	5.4%
R	18	4.4%
P	14	3.4%
Other values (16)	112	27.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	408	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	70	17.2%
I	36	8.8%
L	30	7.4%
E	28	6.9%
C	28	6.9%
T	26	6.4%
A	24	5.9%
O	22	5.4%
R	18	4.4%
P	14	3.4%
Other values (16)	112	27.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	408	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	70	17.2%
I	36	8.8%
L	30	7.4%
E	28	6.9%
C	28	6.9%
T	26	6.4%
A	24	5.9%
O	22	5.4%
R	18	4.4%
P	14	3.4%
Other values (16)	112	27.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	408	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	70	17.2%
I	36	8.8%
L	30	7.4%
E	28	6.9%
C	28	6.9%
T	26	6.4%
A	24	5.9%
O	22	5.4%
R	18	4.4%
P	14	3.4%
Other values (16)	112	27.5%

brandCode
Text

Missing

Distinct	227
Distinct (%)	8.7%
Missing	4781
Missing (%)	64.8%
Memory size	57.8 KiB

Length

Max length	27
Median length	23
Mean length	9.24
Min length	2

Characters and Unicode

Total characters	24024
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	58 ?
Unique (%)	2.2%

Sample

1st row	MISSION
2nd row	BRAND
3rd row	TIC TAC
4th row	WONDERFUL
5th row	RICE-A-RONI

Value	Count	Frequency (%)
hy-vee	299	7.5%
ben	180	4.5%
and	180	4.5%
jerrys	180	4.5%
pepsi	93	2.3%
kroger	89	2.2%
kleenex	88	2.2%
knorr	79	2.0%
doritos	77	1.9%
borden	71	1.8%
Other values (308)	2632	66.3%

Most occurring characters

Value	Count	Frequency (%)
E	3252	13.5%
R	2016	8.4%
S	1594	6.6%
A	1433	6.0%
N	1424	5.9%
	1368	5.7%
I	1289	5.4%
L	1232	5.1%
O	1194	5.0%
T	1102	4.6%
Other values (26)	8120	33.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24024	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	3252	13.5%
R	2016	8.4%
S	1594	6.6%
A	1433	6.0%
N	1424	5.9%
	1368	5.7%
I	1289	5.4%
L	1232	5.1%
O	1194	5.0%
T	1102	4.6%
Other values (26)	8120	33.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24024	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	3252	13.5%
R	2016	8.4%
S	1594	6.6%
A	1433	6.0%
N	1424	5.9%
	1368	5.7%
I	1289	5.4%
L	1232	5.1%
O	1194	5.0%
T	1102	4.6%
Other values (26)	8120	33.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24024	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	3252	13.5%
R	2016	8.4%
S	1594	6.6%
A	1433	6.0%
N	1424	5.9%
	1368	5.7%
I	1289	5.4%
L	1232	5.1%
O	1194	5.0%
T	1102	4.6%
Other values (26)	8120	33.8%

competitorRewardsGroup
Categorical

High correlation Missing

Distinct	30
Distinct (%)	10.9%
Missing	7106
Missing (%)	96.3%
Memory size	57.8 KiB

OSCAR MAYER SAUSAGE LINK	43
MAXWELL HOUSE GROUND COFFEE	36
A.1. DRY RUB	29
OSCAR MAYER BACON	24
TACO BELL TACO SHELLS	21
Other values (25)	122

Length

Max length	47
Median length	32
Mean length	21.418182
Min length	10

Characters and Unicode

Total characters	5890
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	2.5%

Sample

1st row	TACO BELL TACO SHELLS
2nd row	PLANTERS PISTACHIOS
3rd row	SMART ONES
4th row	MAXWELL HOUSE GROUND COFFEE
5th row	FOOD NETWORK KITCHEN INSPIRATIONS COOKING SAUCE

Common Values

Value	Count	Frequency (%)
OSCAR MAYER SAUSAGE LINK	43	0.6%
MAXWELL HOUSE GROUND COFFEE	36	0.5%
A.1. DRY RUB	29	0.4%
OSCAR MAYER BACON	24	0.3%
TACO BELL TACO SHELLS	21	0.3%
LIPTON TEA	20	0.3%
T.G.I. FRIDAY'S FROZEN APPETIZER	13	0.2%
CAPRI SUN BEVERAGE DRINK	13	0.2%
SMART ONES	11	0.1%
FOOD NETWORK KITCHEN INSPIRATIONS COOKING SAUCE	10	0.1%
Other values (20)	55	0.7%
(Missing)	7106	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
oscar	71	7.2%
mayer	71	7.2%
sausage	43	4.4%
link	43	4.4%
taco	42	4.3%
coffee	38	3.9%
maxwell	36	3.7%
house	36	3.7%
ground	36	3.7%
a.1	29	2.9%
Other values (77)	539	54.8%

Most occurring characters

Value	Count	Frequency (%)
	709	12.0%
A	562	9.5%
E	560	9.5%
O	415	7.0%
S	415	7.0%
R	393	6.7%
C	292	5.0%
N	276	4.7%
L	249	4.2%
I	248	4.2%
Other values (25)	1771	30.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5890	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	709	12.0%
A	562	9.5%
E	560	9.5%
O	415	7.0%
S	415	7.0%
R	393	6.7%
C	292	5.0%
N	276	4.7%
L	249	4.2%
I	248	4.2%
Other values (25)	1771	30.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5890	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	709	12.0%
A	562	9.5%
E	560	9.5%
O	415	7.0%
S	415	7.0%
R	393	6.7%
C	292	5.0%
N	276	4.7%
L	249	4.2%
I	248	4.2%
Other values (25)	1771	30.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5890	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	709	12.0%
A	562	9.5%
E	560	9.5%
O	415	7.0%
S	415	7.0%
R	393	6.7%
C	292	5.0%
N	276	4.7%
L	249	4.2%
I	248	4.2%
Other values (25)	1771	30.1%

discountedItemPrice
Real number (ℝ)

High correlation Missing

Distinct	817
Distinct (%)	14.2%
Missing	1612
Missing (%)	21.8%
Infinite	0
Infinite (%)	0.0%
Mean	7.6643664

Minimum	0.16
Maximum	441.58
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0.16
5-th percentile	0.56
Q1	2.34
median	3.99
Q3	7.96
95-th percentile	22.97
Maximum	441.58
Range	441.42
Interquartile range (IQR)	5.62

Descriptive statistics

Standard deviation	15.463778
Coefficient of variation (CV)	2.0176199
Kurtosis	196.739
Mean	7.6643664
Median Absolute Deviation (MAD)	2.19
Skewness	11.362894
Sum	44215.73
Variance	239.12844
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.99	243	3.3%
4.99	196	2.7%
0.56	190	2.6%
2.99	179	2.4%
5.99	176	2.4%
3.49	139	1.9%
2.34	134	1.8%
2.49	106	1.4%
1.99	98	1.3%
1	94	1.3%
Other values (807)	4214	57.1%
(Missing)	1612	21.8%

Value	Count	Frequency (%)
0.16	1	< 0.1%
0.19	13	0.2%
0.25	2	< 0.1%
0.32	2	< 0.1%
0.48	3	< 0.1%
0.5	76	1.0%
0.54	66	0.9%
0.55	2	< 0.1%
0.56	190	2.6%
0.58	1	< 0.1%

Value	Count	Frequency (%)
441.58	1	< 0.1%
245	3	< 0.1%
223.36	5	0.1%
180	6	0.1%
168.84	5	0.1%
115.96	1	< 0.1%
100.48	1	< 0.1%
100	6	0.1%
95.84	4	0.1%
82.34	1	< 0.1%

originalReceiptItemText
Text

Missing

Distinct	1738
Distinct (%)	30.2%
Missing	1621
Missing (%)	22.0%
Memory size	57.8 KiB

Length

Max length	155
Median length	60
Mean length	19.377083
Min length	4

Characters and Unicode

Total characters	111612
Distinct characters	79
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1123 ?
Unique (%)	19.5%

Sample

1st row	MSSN TORTLLA
2nd row	flipbelt level terrain waist pouch, neon yellow, large/32-35
3rd row	flipbelt level terrain waist pouch, neon yellow, large/32-35
4th row	TC NCTN GUM 2MG COOL
5th row	WNDRFL RSTD&SALTED

Value	Count	Frequency (%)
hyv	429	2.1%
oz	284	1.4%
12	233	1.2%
s	231	1.1%
	216	1.1%
ben	196	1.0%
cheese	170	0.8%
sausage	156	0.8%
lf	150	0.7%
milk	150	0.7%
Other values (2393)	17961	89.0%

Most occurring characters

Value	Count	Frequency (%)
	14418	12.9%
E	8283	7.4%
S	6105	5.5%
A	5668	5.1%
R	5635	5.0%
L	5146	4.6%
C	4744	4.3%
O	4697	4.2%
N	4576	4.1%
I	4167	3.7%
Other values (69)	48173	43.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	111612	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	14418	12.9%
E	8283	7.4%
S	6105	5.5%
A	5668	5.1%
R	5635	5.0%
L	5146	4.6%
C	4744	4.3%
O	4697	4.2%
N	4576	4.1%
I	4167	3.7%
Other values (69)	48173	43.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	111612	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	14418	12.9%
E	8283	7.4%
S	6105	5.5%
A	5668	5.1%
R	5635	5.0%
L	5146	4.6%
C	4744	4.3%
O	4697	4.2%
N	4576	4.1%
I	4167	3.7%
Other values (69)	48173	43.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	111612	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	14418	12.9%
E	8283	7.4%
S	6105	5.5%
A	5668	5.1%
R	5635	5.0%
L	5146	4.6%
C	4744	4.3%
O	4697	4.2%
N	4576	4.1%
I	4167	3.7%
Other values (69)	48173	43.2%

itemNumber
Categorical

High correlation Missing

Distinct	47
Distinct (%)	30.7%
Missing	7228
Missing (%)	97.9%
Memory size	57.8 KiB

4023	92
013562300631	6
036000162905	5
078742112138	2
4011	2
Other values (42)	46

Length

Max length	12
Median length	4
Mean length	7.0326797
Min length	4

Characters and Unicode

Total characters	1076
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38 ?
Unique (%)	24.8%

Sample

1st row	4023
2nd row	4023
3rd row	4023
4th row	4023
5th row	000980000069

Common Values

Value	Count	Frequency (%)
4023	92	1.2%
013562300631	6	0.1%
036000162905	5	0.1%
078742112138	2	< 0.1%
4011	2	< 0.1%
021000040247	2	< 0.1%
078742333960	2	< 0.1%
037466017631	2	< 0.1%
085718300512	2	< 0.1%
052100587967	1	< 0.1%
Other values (37)	37	0.5%
(Missing)	7228	97.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4023	92	60.1%
013562300631	6	3.9%
036000162905	5	3.3%
078742333960	2	1.3%
037466017631	2	1.3%
085718300512	2	1.3%
021000040247	2	1.3%
4011	2	1.3%
078742112138	2	1.3%
011594404013	1	0.7%
Other values (37)	37	24.2%

Most occurring characters

Value	Count	Frequency (%)
0	275	25.6%
2	162	15.1%
3	161	15.0%
4	151	14.0%
1	101	9.4%
6	57	5.3%
7	50	4.6%
8	47	4.4%
5	45	4.2%
9	27	2.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1076	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	275	25.6%
2	162	15.1%
3	161	15.0%
4	151	14.0%
1	101	9.4%
6	57	5.3%
7	50	4.6%
8	47	4.4%
5	45	4.2%
9	27	2.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1076	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	275	25.6%
2	162	15.1%
3	161	15.0%
4	151	14.0%
1	101	9.4%
6	57	5.3%
7	50	4.6%
8	47	4.4%
5	45	4.2%
9	27	2.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1076	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	275	25.6%
2	162	15.1%
3	161	15.0%
4	151	14.0%
1	101	9.4%
6	57	5.3%
7	50	4.6%
8	47	4.4%
5	45	4.2%
9	27	2.5%

originalMetaBriteQuantityPurchased
Categorical

High correlation Missing

Distinct	2
Distinct (%)	13.3%
Missing	7366
Missing (%)	99.8%
Memory size	57.8 KiB

1.0	12
2.0	3

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	45
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	2.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	12	0.2%
2.0	3	< 0.1%
(Missing)	7366	99.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	12	80.0%
2.0	3	20.0%

Most occurring characters

Value	Count	Frequency (%)
.	15	33.3%
0	15	33.3%
1	12	26.7%
2	3	6.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	15	33.3%
0	15	33.3%
1	12	26.7%
2	3	6.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	15	33.3%
0	15	33.3%
1	12	26.7%
2	3	6.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	15	33.3%
0	15	33.3%
1	12	26.7%
2	3	6.7%

pointsEarned
Real number (ℝ)

High correlation Missing

Distinct	277
Distinct (%)	29.9%
Missing	6454
Missing (%)	87.4%
Infinite	0
Infinite (%)	0.0%
Mean	140.50831

Minimum	4.5
Maximum	870
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	4.5
5-th percentile	5
Q1	28.05
median	50
Q3	165.45
95-th percentile	870
Maximum	870
Range	865.5
Interquartile range (IQR)	137.4

Descriptive statistics

Standard deviation	223.00559
Coefficient of variation (CV)	1.5871346
Kurtosis	5.959663
Mean	140.50831
Median Absolute Deviation (MAD)	30.1
Skewness	2.6550999
Sum	130251.2
Variance	49731.495
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	123	1.7%
210	89	1.2%
870	70	0.9%
5	70	0.9%
25	60	0.8%
30	40	0.5%
34.9	21	0.3%
55.9	20	0.3%
10	19	0.3%
19.9	13	0.2%
Other values (267)	402	5.4%
(Missing)	6454	87.4%

Value	Count	Frequency (%)
4.5	1	< 0.1%
5	70	0.9%
10	19	0.3%
12.5	3	< 0.1%
12.9	1	< 0.1%
15	2	< 0.1%
16.2	1	< 0.1%
16.3	1	< 0.1%
16.5	1	< 0.1%
16.7	1	< 0.1%

Value	Count	Frequency (%)
870	70	0.9%
844.2	2	< 0.1%
294	1	< 0.1%
292	1	< 0.1%
289	1	< 0.1%
287	1	< 0.1%
285.5	1	< 0.1%
280	3	< 0.1%
277.5	1	< 0.1%
274	1	< 0.1%

targetPrice
Categorical

High correlation Missing

Distinct	2
Distinct (%)	0.5%
Missing	7003
Missing (%)	94.9%
Memory size	57.8 KiB

800	299
77	79

Length

Max length	3
Median length	3
Mean length	2.7910053
Min length	2

Characters and Unicode

Total characters	1055
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	800
2nd row	800
3rd row	800
4th row	800
5th row	800

Common Values

Value	Count	Frequency (%)
800	299	4.1%
77	79	1.1%
(Missing)	7003	94.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
800	299	79.1%
77	79	20.9%

Most occurring characters

Value	Count	Frequency (%)
0	598	56.7%
8	299	28.3%
7	158	15.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1055	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	598	56.7%
8	299	28.3%
7	158	15.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1055	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	598	56.7%
8	299	28.3%
7	158	15.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1055	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	598	56.7%
8	299	28.3%
7	158	15.0%

competitiveProduct
Boolean

High correlation Missing

Distinct	2
Distinct (%)	0.3%
Missing	6736
Missing (%)	91.3%
Memory size	57.8 KiB

True	468
False	177
(Missing)	6736

Value	Count	Frequency (%)
True	468	6.3%
False	177	2.4%
(Missing)	6736	91.3%

originalFinalPrice
Categorical

High correlation Missing

Distinct	2
Distinct (%)	22.2%
Missing	7372
Missing (%)	99.9%
Memory size	57.8 KiB

1.00	6
10.00	3

Length

Max length	5
Median length	4
Mean length	4.3333333
Min length	4

Characters and Unicode

Total characters	39
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.00
2nd row	1.00
3rd row	10.00
4th row	1.00
5th row	1.00

Common Values

Value	Count	Frequency (%)
1.00	6	0.1%
10.00	3	< 0.1%
(Missing)	7372	99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.00	6	66.7%
10.00	3	33.3%

Most occurring characters

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	39	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	39	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	39	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

originalMetaBriteItemPrice
Categorical

High correlation Missing

Distinct	2
Distinct (%)	22.2%
Missing	7372
Missing (%)	99.9%
Memory size	57.8 KiB

1.00	6
10.00	3

Length

Max length	5
Median length	4
Mean length	4.3333333
Min length	4

Characters and Unicode

Total characters	39
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.00
2nd row	1.00
3rd row	10.00
4th row	1.00
5th row	1.00

Common Values

Value	Count	Frequency (%)
1.00	6	0.1%
10.00	3	< 0.1%
(Missing)	7372	99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.00	6	66.7%
10.00	3	33.3%

Most occurring characters

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	39	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	39	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	39	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21	53.8%
1	9	23.1%
.	9	23.1%

deleted
Boolean

Constant Missing

Distinct	1
Distinct (%)	11.1%
Missing	7372
Missing (%)	99.9%
Memory size	57.8 KiB

True	9
(Missing)	7372

Value	Count	Frequency (%)
True	9	0.1%
(Missing)	7372	99.9%

priceAfterCoupon
Real number (ℝ)

High correlation Missing

Distinct	334
Distinct (%)	34.9%
Missing	6425
Missing (%)	87.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.393358

Minimum	0.19
Maximum	245
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0.19
5-th percentile	0.56
Q1	2.685
median	4.99
Q3	11.99
95-th percentile	28.57
Maximum	245
Range	244.81
Interquartile range (IQR)	9.305

Descriptive statistics

Standard deviation	18.695615
Coefficient of variation (CV)	1.7988041
Kurtosis	75.037528
Mean	10.393358
Median Absolute Deviation (MAD)	3.2
Skewness	7.4840527
Sum	9936.05
Variance	349.52601
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28.57	50	0.7%
11.99	47	0.6%
22.97	44	0.6%
3.99	39	0.5%
1	25	0.3%
5.99	24	0.3%
0.56	23	0.3%
2.99	21	0.3%
4.99	20	0.3%
3.49	20	0.3%
Other values (324)	643	8.7%
(Missing)	6425	87.0%

Value	Count	Frequency (%)
0.19	2	< 0.1%
0.5	20	0.3%
0.54	8	0.1%
0.56	23	0.3%
0.6	1	< 0.1%
0.77	2	< 0.1%
0.79	2	< 0.1%
0.8	1	< 0.1%
0.88	4	0.1%
0.89	1	< 0.1%

Value	Count	Frequency (%)
245	1	< 0.1%
223.36	2	< 0.1%
180	1	< 0.1%
168.84	1	< 0.1%
115.96	1	< 0.1%
100	2	< 0.1%
95.84	2	< 0.1%
80	1	< 0.1%
79.84	1	< 0.1%
56	2	< 0.1%

metabriteCampaignId
Text

Missing

Distinct	75
Distinct (%)	8.7%
Missing	6518
Missing (%)	88.3%
Memory size	57.8 KiB

Length

Max length	66
Median length	46
Mean length	28.724218
Min length	11

Characters and Unicode

Total characters	24789
Distinct characters	44
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30 ?
Unique (%)	3.5%

Sample

1st row	KRAFT SINGLES
2nd row	JUST BARE FRESH CHICKEN BREAST FILETS
3rd row	JUST BARE FRESH CHICKEN BREAST FILETS
4th row	DORITOS NACHO CHEESE MULTI SERVE
5th row	DORITOS NACHO CHEESE MULTI SERVE

Value	Count	Frequency (%)
and	207	4.6%
	200	4.4%
cream	186	4.1%
12	183	4.0%
ice	181	4.0%
ben	180	4.0%
jerrys	180	4.0%
pack	173	3.8%
cheese	123	2.7%
serve	113	2.5%
Other values (195)	2813	62.0%

Most occurring characters

Value	Count	Frequency (%)
	3676	14.8%
E	3048	12.3%
R	1710	6.9%
S	1691	6.8%
A	1628	6.6%
C	1412	5.7%
I	1309	5.3%
N	1253	5.1%
T	942	3.8%
O	861	3.5%
Other values (34)	7259	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24789	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3676	14.8%
E	3048	12.3%
R	1710	6.9%
S	1691	6.8%
A	1628	6.6%
C	1412	5.7%
I	1309	5.3%
N	1253	5.1%
T	942	3.8%
O	861	3.5%
Other values (34)	7259	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24789	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3676	14.8%
E	3048	12.3%
R	1710	6.9%
S	1691	6.8%
A	1628	6.6%
C	1412	5.7%
I	1309	5.3%
N	1253	5.1%
T	942	3.8%
O	861	3.5%
Other values (34)	7259	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24789	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3676	14.8%
E	3048	12.3%
R	1710	6.9%
S	1691	6.8%
A	1628	6.6%
C	1412	5.7%
I	1309	5.3%
N	1253	5.1%
T	942	3.8%
O	861	3.5%
Other values (34)	7259	29.3%

receipt_item_id
Text

Unique

Distinct	7381
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	57.8 KiB

Length

Max length	28
Median length	27
Mean length	26.988619
Min length	26

Characters and Unicode

Total characters	199203
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7381 ?
Unique (%)	100.0%

Sample

1st row	5ff1e1cd0a720f052300056f_1
2nd row	5ff5d1f20a720f05230005db_1
3rd row	5ff5d1f20a720f05230005db_2
4th row	5ff5d1f20a720f05230005db_3
5th row	5ff5d1f20a720f05230005db_4

Value	Count	Frequency (%)
5ff1e1cd0a720f052300056f_1	1	< 0.1%
5ffe22a20a720f05ac0061d7_1	1	< 0.1%
5ff5d1f20a720f05230005db_2	1	< 0.1%
5ff5d1f20a720f05230005db_3	1	< 0.1%
5ff5d1f20a720f05230005db_4	1	< 0.1%
5ff74fd10a720f0523000619_1	1	< 0.1%
5ff7942e0a720f0523000637_1	1	< 0.1%
5ff7942e0a720f0523000637_2	1	< 0.1%
5ff8da390a7214adca000013_1	1	< 0.1%
5ff8da620a7214adca00001d_1	1	< 0.1%
Other values (7371)	7371	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	62920	31.6%
2	16136	8.1%
a	15529	7.8%
f	11783	5.9%
7	11185	5.6%
1	10606	5.3%
5	10473	5.3%
3	9720	4.9%
6	9486	4.8%
_	7381	3.7%
Other values (7)	33984	17.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	199203	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	62920	31.6%
2	16136	8.1%
a	15529	7.8%
f	11783	5.9%
7	11185	5.6%
1	10606	5.3%
5	10473	5.3%
3	9720	4.9%
6	9486	4.8%
_	7381	3.7%
Other values (7)	33984	17.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	199203	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	62920	31.6%
2	16136	8.1%
a	15529	7.8%
f	11783	5.9%
7	11185	5.6%
1	10606	5.3%
5	10473	5.3%
3	9720	4.9%
6	9486	4.8%
_	7381	3.7%
Other values (7)	33984	17.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	199203	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	62920	31.6%
2	16136	8.1%
a	15529	7.8%
f	11783	5.9%
7	11185	5.6%
1	10606	5.3%
5	10473	5.3%
3	9720	4.9%
6	9486	4.8%
_	7381	3.7%
Other values (7)	33984	17.1%

items_in_receipt_list
Real number (ℝ)

High correlation Missing

Distinct	49
Distinct (%)	0.7%
Missing	464
Missing (%)	6.3%
Infinite	0
Infinite (%)	0.0%
Mean	240.01084

Minimum	1
Maximum	689
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	93
median	167
Q3	309
95-th percentile	689
Maximum	689
Range	688
Interquartile range (IQR)	216

Descriptive statistics

Standard deviation	221.92227
Coefficient of variation (CV)	0.92463433
Kurtosis	-0.28839641
Mean	240.01084
Median Absolute Deviation (MAD)	136
Skewness	0.96207664
Sum	1660155
Variance	49249.492
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
689	459	6.2%
1	458	6.2%
670	450	6.1%
599	381	5.2%
5	372	5.0%
133	248	3.4%
303	217	2.9%
214	203	2.8%
212	194	2.6%
335	185	2.5%
Other values (39)	3750	50.8%
(Missing)	464	6.3%

Value	Count	Frequency (%)
1	458	6.2%
2	149	2.0%
3	32	0.4%
4	174	2.4%
5	372	5.0%
6	23	0.3%
7	15	0.2%
8	2	< 0.1%
9	90	1.2%
10	115	1.6%

Value	Count	Frequency (%)
689	459	6.2%
670	450	6.1%
599	381	5.2%
348	127	1.7%
341	124	1.7%
335	185	2.5%
309	183	2.5%
303	217	2.9%
240	148	2.0%
229	99	1.3%

summary_list_difference_count
Real number (ℝ)

High correlation Missing Zeros

Distinct	7
Distinct (%)	0.1%
Missing	513
Missing (%)	7.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.064647641

Minimum	-10
Maximum	4
Zeros	6756
Zeros (%)	91.5%
Negative	92
Negative (%)	1.2%
Memory size	57.8 KiB

Quantile statistics

Minimum	-10
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	4
Range	14
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.81178308
Coefficient of variation (CV)	-12.557041
Kurtosis	141.21441
Mean	-0.064647641
Median Absolute Deviation (MAD)	0
Skewness	-11.677228
Sum	-444
Variance	0.65899176
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	6756	91.5%
-1	48	0.7%
-10	44	0.6%
2	16	0.2%
4	2	< 0.1%
1	1	< 0.1%
3	1	< 0.1%
(Missing)	513	7.0%

Value	Count	Frequency (%)
-10	44	0.6%
-1	48	0.7%
0	6756	91.5%
1	1	< 0.1%
2	16	0.2%
3	1	< 0.1%
4	2	< 0.1%

Value	Count	Frequency (%)
4	2	< 0.1%
3	1	< 0.1%
2	16	0.2%
1	1	< 0.1%
0	6756	91.5%
-1	48	0.7%
-10	44	0.6%

hours_diff
Real number (ℝ)

High correlation Missing Zeros

Distinct	67
Distinct (%)	1.1%
Missing	1301
Missing (%)	17.6%
Infinite	0
Infinite (%)	0.0%
Mean	7.4424764

Minimum	0
Maximum	1891.8567
Zeros	439
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.056666667
median	0.12944444
Q3	0.18805556
95-th percentile	5.5
Maximum	1891.8567
Range	1891.8567
Interquartile range (IQR)	0.13138889

Descriptive statistics

Standard deviation	102.9143
Coefficient of variation (CV)	13.827965
Kurtosis	240.0396
Mean	7.4424764
Median Absolute Deviation (MAD)	0.071944444
Skewness	15.443841
Sum	45250.256
Variance	10591.354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0002777777778	593	8.0%
1.181944444	459	6.2%
5.5	450	6.1%
0	439	5.9%
0.1447222222	203	2.8%
0.2241666667	194	2.6%
0.1030555556	186	2.5%
0.1191666667	183	2.5%
0.1880555556	176	2.4%
0.1194444444	155	2.1%
Other values (57)	3042	41.2%
(Missing)	1301	17.6%

Value	Count	Frequency (%)
0	439	5.9%
0.0002777777778	593	8.0%
0.0005555555556	62	0.8%
0.0008333333333	14	0.2%
0.001111111111	8	0.1%
0.001388888889	2	< 0.1%
0.001666666667	7	0.1%
0.001944444444	10	0.1%
0.002222222222	9	0.1%
0.0025	13	0.2%

Value	Count	Frequency (%)
1891.856667	5	0.1%
1555.365	5	0.1%
1537.339444	5	0.1%
1440.754722	11	0.1%
102.0030556	4	0.1%
72.58861111	1	< 0.1%
48.00277778	2	< 0.1%
48.00166667	1	< 0.1%
48.00111111	2	< 0.1%
48.00083333	1	< 0.1%

minutes_diff
Real number (ℝ)

High correlation Missing Zeros

Distinct	67
Distinct (%)	1.1%
Missing	1301
Missing (%)	17.6%
Infinite	0
Infinite (%)	0.0%
Mean	446.54858

Minimum	0
Maximum	113511.4
Zeros	439
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	57.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.4
median	7.7666667
Q3	11.283333
95-th percentile	330
Maximum	113511.4
Range	113511.4
Interquartile range (IQR)	7.8833333

Descriptive statistics

Standard deviation	6174.8581
Coefficient of variation (CV)	13.827965
Kurtosis	240.0396
Mean	446.54858
Median Absolute Deviation (MAD)	4.3166667
Skewness	15.443841
Sum	2715015.4
Variance	38128873
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01666666667	593	8.0%
70.91666667	459	6.2%
330	450	6.1%
0	439	5.9%
8.683333333	203	2.8%
13.45	194	2.6%
6.183333333	186	2.5%
7.15	183	2.5%
11.28333333	176	2.4%
7.166666667	155	2.1%
Other values (57)	3042	41.2%
(Missing)	1301	17.6%

Value	Count	Frequency (%)
0	439	5.9%
0.01666666667	593	8.0%
0.03333333333	62	0.8%
0.05	14	0.2%
0.06666666667	8	0.1%
0.08333333333	2	< 0.1%
0.1	7	0.1%
0.1166666667	10	0.1%
0.1333333333	9	0.1%
0.15	13	0.2%

Value	Count	Frequency (%)
113511.4	5	0.1%
93321.9	5	0.1%
92240.36667	5	0.1%
86445.28333	11	0.1%
6120.183333	4	0.1%
4355.316667	1	< 0.1%
2880.166667	2	< 0.1%
2880.1	1	< 0.1%
2880.066667	2	< 0.1%
2880.05	1	< 0.1%

Interactions

Correlations

	competitiveProduct	competitorRewardsGroup	discountedItemPrice	finalPrice	hours_diff	itemNumber	itemPrice	items_in_receipt_list	minutes_diff	needsFetchReview	needsFetchReviewReason	originalFinalPrice	originalMetaBriteBarcode	originalMetaBriteDescription	originalMetaBriteItemPrice	originalMetaBriteQuantityPurchased	partnerItemId	pointsEarned	pointsPayerId	priceAfterCoupon	purchasedItemCount	quantityPurchased	rewardsProductPartnerId	summary_list_difference_count	targetPrice	total_receipt_points_earned	total_receipt_spent	userFlaggedBarcode	userFlaggedDescription	userFlaggedPrice	userFlaggedQuantity
competitiveProduct	1.000	1.000	0.768	0.813	0.000	1.000	0.081	0.432	0.000	0.000	0.593	1.000	1.000	0.000	1.000	1.000	0.561	0.734	0.237	0.642	0.432	0.235	0.647	0.000	1.000	0.382	0.427	1.000	0.000	1.000	1.000
competitorRewardsGroup	1.000	1.000	0.709	0.709	1.000	NaN	0.000	0.240	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.389	0.000	0.000	0.621	0.234	0.198	0.869	1.000	0.000	0.045	0.242	0.000	0.000	0.000	0.000
discountedItemPrice	0.768	0.709	1.000	1.000	-0.044	0.924	1.000	-0.018	-0.044	0.812	1.000	0.000	0.442	0.000	0.000	1.000	-0.035	0.967	0.342	1.000	0.005	0.431	0.454	NaN	0.000	0.037	-0.005	0.000	0.000	0.000	0.000
finalPrice	0.813	0.709	1.000	1.000	-0.105	0.924	1.000	-0.081	-0.105	0.479	0.875	0.707	0.641	0.762	0.707	0.961	-0.103	0.939	0.541	1.000	-0.064	0.398	0.528	0.049	0.988	0.005	-0.049	0.830	0.866	0.943	0.432
hours_diff	0.000	1.000	-0.044	-0.105	1.000	1.000	-0.104	0.752	1.000	0.086	1.000	0.000	0.664	0.935	0.000	0.160	0.624	0.124	0.445	-0.009	0.752	0.039	0.384	0.115	0.997	0.696	0.766	0.160	1.000	0.232	0.011
itemNumber	1.000	NaN	0.924	0.924	1.000	1.000	0.838	1.000	1.000	1.000	1.000	0.000	0.361	0.000	0.000	1.000	0.923	0.918	0.967	0.000	1.000	0.838	0.911	1.000	0.000	0.838	1.000	0.000	0.000	0.000	0.000
itemPrice	0.081	0.000	1.000	1.000	-0.104	0.838	1.000	-0.080	-0.104	0.242	0.989	1.000	1.000	1.000	1.000	0.000	-0.103	0.939	0.207	1.000	-0.064	0.398	0.000	0.049	1.000	0.005	-0.049	1.000	1.000	1.000	1.000
items_in_receipt_list	0.432	0.240	-0.018	-0.081	0.752	1.000	-0.080	1.000	0.752	0.671	0.358	1.000	1.000	1.000	1.000	1.000	0.696	0.115	0.331	-0.313	0.999	0.202	0.261	0.141	1.000	0.786	0.938	1.000	1.000	1.000	1.000
minutes_diff	0.000	1.000	-0.044	-0.105	1.000	1.000	-0.104	0.752	1.000	0.086	1.000	0.000	0.664	0.935	0.000	0.160	0.624	0.124	0.445	-0.009	0.752	0.039	0.384	0.115	0.997	0.696	0.766	0.160	1.000	0.232	0.011
needsFetchReview	0.000	1.000	0.812	0.479	0.086	1.000	0.242	0.671	0.086	1.000	1.000	1.000	1.000	1.000	1.000	0.000	0.380	0.482	0.328	NaN	0.679	0.219	0.372	0.554	1.000	0.701	0.679	0.713	1.000	0.553	0.481
needsFetchReviewReason	0.593	0.000	1.000	0.875	1.000	1.000	0.989	0.358	1.000	1.000	1.000	0.000	0.000	0.000	0.000	1.000	0.596	0.671	0.956	NaN	0.360	0.854	0.947	0.072	0.000	0.468	0.360	1.000	1.000	1.000	1.000
originalFinalPrice	1.000	0.000	0.000	0.707	0.000	0.000	1.000	1.000	0.000	1.000	0.000	1.000	0.707	1.000	0.707	0.707	0.926	1.000	1.000	0.000	1.000	1.000	0.707	1.000	1.000	1.000	1.000	0.707	0.000	0.707	0.707
originalMetaBriteBarcode	1.000	0.000	0.442	0.641	0.664	0.361	1.000	1.000	0.664	1.000	0.000	0.707	1.000	0.762	0.707	0.707	0.277	0.853	0.742	0.000	1.000	1.000	0.694	1.000	0.856	0.311	1.000	1.000	0.000	0.707	0.707
originalMetaBriteDescription	0.000	0.000	0.000	0.762	0.935	0.000	1.000	1.000	0.935	1.000	0.000	1.000	0.762	1.000	1.000	1.000	0.935	1.000	0.762	0.000	1.000	1.000	0.762	1.000	1.000	0.415	1.000	0.762	0.000	1.000	1.000
originalMetaBriteItemPrice	1.000	0.000	0.000	0.707	0.000	0.000	1.000	1.000	0.000	1.000	0.000	0.707	0.707	1.000	1.000	0.707	0.926	1.000	1.000	0.000	1.000	1.000	0.707	1.000	1.000	1.000	1.000	0.707	0.000	0.707	0.707
originalMetaBriteQuantityPurchased	1.000	0.000	1.000	0.961	0.160	1.000	0.000	1.000	0.160	0.000	1.000	0.707	0.707	1.000	0.707	1.000	0.920	1.000	1.000	0.000	1.000	0.000	0.961	1.000	1.000	1.000	1.000	0.707	0.000	0.707	0.707
partnerItemId	0.561	0.389	-0.035	-0.103	0.624	0.923	-0.103	0.696	0.624	0.380	0.596	0.926	0.277	0.935	0.926	0.920	1.000	0.052	0.496	-0.171	0.693	0.150	0.378	0.107	0.408	0.585	0.686	0.544	0.561	0.345	0.371
pointsEarned	0.734	0.000	0.967	0.939	0.124	0.918	0.939	0.115	0.124	0.482	0.671	1.000	0.853	1.000	1.000	1.000	0.052	1.000	0.620	0.958	0.115	0.331	0.620	NaN	0.992	0.499	0.328	0.987	1.000	0.922	1.000
pointsPayerId	0.237	0.000	0.342	0.541	0.445	0.967	0.207	0.331	0.445	0.328	0.956	1.000	0.742	0.762	1.000	1.000	0.496	0.620	1.000	0.368	0.331	0.226	1.000	1.000	0.996	0.381	0.427	0.991	0.862	0.987	1.000
priceAfterCoupon	0.642	0.621	1.000	1.000	-0.009	0.000	1.000	-0.313	-0.009	NaN	NaN	0.000	0.000	0.000	0.000	0.000	-0.171	0.958	0.368	1.000	-0.207	0.374	0.409	NaN	0.000	-0.223	-0.312	0.000	0.000	0.000	0.000
purchasedItemCount	0.432	0.234	0.005	-0.064	0.752	1.000	-0.064	0.999	0.752	0.679	0.360	1.000	1.000	1.000	1.000	1.000	0.693	0.115	0.331	-0.207	1.000	0.198	0.261	0.101	1.000	0.788	0.937	1.000	1.000	1.000	1.000
quantityPurchased	0.235	0.198	0.431	0.398	0.039	0.838	0.398	0.202	0.039	0.219	0.854	1.000	1.000	1.000	1.000	0.000	0.150	0.331	0.226	0.374	0.198	1.000	0.218	0.065	0.047	0.231	0.133	0.318	0.520	0.357	0.701
rewardsProductPartnerId	0.647	0.869	0.454	0.528	0.384	0.911	0.000	0.261	0.384	0.372	0.947	0.707	0.694	0.762	0.707	0.961	0.378	0.620	1.000	0.409	0.261	0.218	1.000	0.000	0.996	0.352	0.331	0.992	0.862	0.692	0.990
summary_list_difference_count	0.000	1.000	NaN	0.049	0.115	1.000	0.049	0.141	0.115	0.554	0.072	1.000	1.000	1.000	1.000	1.000	0.107	NaN	1.000	NaN	0.101	0.065	0.000	1.000	1.000	0.075	0.137	0.525	0.635	0.630	0.370
targetPrice	1.000	0.000	0.000	0.988	0.997	0.000	1.000	1.000	0.997	1.000	0.000	1.000	0.856	1.000	1.000	1.000	0.408	0.992	0.996	0.000	1.000	0.047	0.996	1.000	1.000	0.924	1.000	0.985	0.000	0.978	1.000
total_receipt_points_earned	0.382	0.045	0.037	0.005	0.696	0.838	0.005	0.786	0.696	0.701	0.468	1.000	0.311	0.415	1.000	1.000	0.585	0.499	0.381	-0.223	0.788	0.231	0.352	0.075	0.924	1.000	0.740	0.105	0.391	0.195	0.150
total_receipt_spent	0.427	0.242	-0.005	-0.049	0.766	1.000	-0.049	0.938	0.766	0.679	0.360	1.000	1.000	1.000	1.000	1.000	0.686	0.328	0.427	-0.312	0.937	0.133	0.331	0.137	1.000	0.740	1.000	1.000	1.000	1.000	1.000
userFlaggedBarcode	1.000	0.000	0.000	0.830	0.160	0.000	1.000	1.000	0.160	0.713	1.000	0.707	1.000	0.762	0.707	0.707	0.544	0.987	0.991	0.000	1.000	0.318	0.992	0.525	0.985	0.105	1.000	1.000	0.998	0.802	0.520
userFlaggedDescription	0.000	0.000	0.000	0.866	1.000	0.000	1.000	1.000	1.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.561	1.000	0.862	0.000	1.000	0.520	0.862	0.635	0.000	0.391	1.000	0.998	1.000	0.882	0.529
userFlaggedPrice	1.000	0.000	0.000	0.943	0.232	0.000	1.000	1.000	0.232	0.553	1.000	0.707	0.707	1.000	0.707	0.707	0.345	0.922	0.987	0.000	1.000	0.357	0.692	0.630	0.978	0.195	1.000	0.802	0.882	1.000	0.479
userFlaggedQuantity	1.000	0.000	0.000	0.432	0.011	0.000	1.000	1.000	0.011	0.481	1.000	0.707	0.707	1.000	0.707	0.707	0.371	1.000	1.000	0.000	1.000	0.701	0.990	0.370	1.000	0.150	1.000	0.520	0.529	0.479	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	receipt_id	purchasedItemCount	createdate	datescanned	finisheddate	modifydate	pointsawardeddate	purchasedate	total_receipt_points_earned	total_receipt_spent	barcode	description	finalPrice	itemPrice	needsFetchReview	partnerItemId	preventTargetGapPoints	quantityPurchased	userFlaggedBarcode	userFlaggedNewItem	userFlaggedPrice	userFlaggedQuantity	needsFetchReviewReason	pointsNotAwardedReason	pointsPayerId	rewardsGroup	rewardsProductPartnerId	userFlaggedDescription	originalMetaBriteBarcode	originalMetaBriteDescription	brandCode	competitorRewardsGroup	discountedItemPrice	originalReceiptItemText	itemNumber	originalMetaBriteQuantityPurchased	pointsEarned	targetPrice	competitiveProduct	originalFinalPrice	originalMetaBriteItemPrice	deleted	priceAfterCoupon	metabriteCampaignId	receipt_item_id	items_in_receipt_list	summary_list_difference_count	hours_diff	minutes_diff
0	5ff1e1cd0a720f052300056f	1.0	2021-01-03 15:25:01	2021-01-03 15:25:01	2021-01-03 15:25:02	2021-01-03 15:25:02	2021-01-03 15:25:02	2021-01-03 15:25:01	5.0	2.230000	None	MSSN TORTLLA	2.23	2.23	NaN	1009	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	MISSION	TACO BELL TACO SHELLS	2.23	MSSN TORTLLA	None	NaN	None	None	NaN	None	None	NaN	None	None	5ff1e1cd0a720f052300056f_1	1.0	0.0	0.000278	0.016667
1	5ff5d1f20a720f05230005db	4.0	2021-01-06 15:06:26	2021-01-06 15:06:26	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-05 15:06:26	5.0	18.200001	021000051113	None	4.55	4.55	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	SARGENTO GRATED PARMESAN CHEESE	5e7cf838f221c312e698a628	None	None	None	None	None	None	None	None	NaN	None	None	True	None	None	NaN	None	None	5ff5d1f20a720f05230005db_1	4.0	0.0	0.000278	0.016667
2	5ff5d1f20a720f05230005db	4.0	2021-01-06 15:06:26	2021-01-06 15:06:26	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-05 15:06:26	5.0	18.200001	021000051113	None	4.55	4.55	NaN	2	NaN	1.0	None	NaN	None	NaN	None	None	None	SARGENTO GRATED PARMESAN CHEESE	5e7cf838f221c312e698a628	None	None	None	None	None	None	None	None	NaN	None	None	True	None	None	NaN	None	None	5ff5d1f20a720f05230005db_2	4.0	0.0	0.000278	0.016667
3	5ff5d1f20a720f05230005db	4.0	2021-01-06 15:06:26	2021-01-06 15:06:26	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-05 15:06:26	5.0	18.200001	021000051113	None	4.55	4.55	NaN	3	NaN	1.0	None	NaN	None	NaN	None	None	None	SARGENTO GRATED PARMESAN CHEESE	5e7cf838f221c312e698a628	None	None	None	None	None	None	None	None	NaN	None	None	True	None	None	NaN	None	None	5ff5d1f20a720f05230005db_3	4.0	0.0	0.000278	0.016667
4	5ff5d1f20a720f05230005db	4.0	2021-01-06 15:06:26	2021-01-06 15:06:26	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-06 15:06:27	2021-01-05 15:06:26	5.0	18.200001	021000051113	None	4.55	4.55	NaN	4	NaN	1.0	None	NaN	None	NaN	None	None	None	SARGENTO GRATED PARMESAN CHEESE	5e7cf838f221c312e698a628	None	None	None	None	None	None	None	None	NaN	None	None	True	None	None	NaN	None	None	5ff5d1f20a720f05230005db_4	4.0	0.0	0.000278	0.016667
5	5ff74fd10a720f0523000619	1.0	2021-01-07 18:15:45	2021-01-07 18:15:45	2021-01-07 18:15:47	2021-01-07 18:15:47	2021-01-07 18:15:47	2021-01-06 18:15:45	5.0	1.000000	043000204399	Jell-O Instant Pudding & Pie Filling French Vanilla, 3.4 Oz	1	1.00	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	None	559c2234e4b06aca36af13c6	None	None	None	None	None	None	None	None	NaN	None	None	NaN	None	None	NaN	None	None	5ff74fd10a720f0523000619_1	1.0	0.0	0.000556	0.033333
6	5ff7942e0a720f0523000637	2.0	2021-01-05 23:07:26	2021-01-05 23:07:26	2021-01-07 23:07:36	2021-01-07 23:07:36	2021-01-07 05:07:29	2021-01-04 23:07:26	2005.0	1.000000	1234	None	None	NaN	True	2	True	NaN	1234	True	None	NaN	USER_FLAGGED	None	None	None	None		None	None	None	None	None	None	None	NaN	None	None	NaN	None	None	NaN	None	None	5ff7942e0a720f0523000637_1	1.0	-1.0	30.000833	1800.050000
7	5ff7942e0a720f0523000637	2.0	2021-01-05 23:07:26	2021-01-05 23:07:26	2021-01-07 23:07:36	2021-01-07 23:07:36	2021-01-07 05:07:29	2021-01-04 23:07:26	2005.0	1.000000	4011	ITEM NOT FOUND	1	1.00	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	NaN	None	None	NaN	None	None	5ff7942e0a720f0523000637_2	1.0	-1.0	30.000833	1800.050000
8	5ff8da390a7214adca000013	1.0	2021-01-08 22:18:33	2021-01-08 22:18:33	2021-01-08 22:18:34	2021-01-08 22:18:34	2021-01-08 22:18:34	2021-01-01 00:00:00	350.0	10.000000	305210154278	VASELINE COCOA BUTTER SKIN MOISTURIZER LOTION CONDITIONING RP 34.5 OZ	10.00	10.00	NaN	0	NaN	1.0	None	NaN	None	NaN	None	None	5332f5f6e4b03c9a25efd0b4	VASELINE HAND AND BODY LOTION	5332f5f6e4b03c9a25efd0b4	None	None	None	BRAND	None	None	None	None	NaN	100.0	None	NaN	None	None	NaN	None	None	5ff8da390a7214adca000013_1	1.0	0.0	0.000278	0.016667
9	5ff8da620a7214adca00001d	1.0	2021-01-08 22:19:14	2021-01-08 22:19:14	NaT	2021-01-08 22:19:15	2021-01-08 22:19:14	2021-01-07 22:19:14	750.0	1.000000	075925306254	None	1	1.00	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	SARGENTO NATURAL SHREDDED CHEESE 6OZ OR LARGER	5e7cf838f221c312e698a628	None	None	None	None	None	None	None	None	NaN	None	None	True	None	None	NaN	None	None	5ff8da620a7214adca00001d_1	1.0	0.0	0.000000	0.000000

	receipt_id	purchasedItemCount	createdate	datescanned	finisheddate	modifydate	pointsawardeddate	purchasedate	total_receipt_points_earned	total_receipt_spent	barcode	description	finalPrice	itemPrice	needsFetchReview	partnerItemId	preventTargetGapPoints	quantityPurchased	userFlaggedBarcode	userFlaggedNewItem	userFlaggedPrice	userFlaggedQuantity	needsFetchReviewReason	pointsNotAwardedReason	pointsPayerId	rewardsGroup	rewardsProductPartnerId	userFlaggedDescription	originalMetaBriteBarcode	originalMetaBriteDescription	brandCode	competitorRewardsGroup	discountedItemPrice	originalReceiptItemText	itemNumber	originalMetaBriteQuantityPurchased	pointsEarned	targetPrice	competitiveProduct	originalFinalPrice	originalMetaBriteItemPrice	deleted	priceAfterCoupon	metabriteCampaignId	receipt_item_id	items_in_receipt_list	summary_list_difference_count	hours_diff	minutes_diff
7371	603aab2f0a7217c72c00023a	2.0	2021-02-27 20:27:27.000	2021-02-27 20:27:27.000	NaT	2021-02-27 20:27:28.000	NaT	2020-08-17	25.0	34.959999	B076FJ92M4	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	22.97	22.97	NaN	0	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	22.97	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	None	NaN	None	None	NaN	None	None	NaN	22.97	None	603aab2f0a7217c72c00023a_1	2.0	0.0	NaN	NaN
7372	603aab2f0a7217c72c00023a	2.0	2021-02-27 20:27:27.000	2021-02-27 20:27:27.000	NaT	2021-02-27 20:27:28.000	NaT	2020-08-17	25.0	34.959999	B07BRRLSVC	thindust summer face mask - sun protection neck gaiter for outdooractivities	11.99	11.99	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	11.99	thindust summer face mask - sun protection neck gaiter for outdooractivities	None	NaN	None	None	NaN	None	None	NaN	11.99	None	603aab2f0a7217c72c00023a_2	2.0	0.0	NaN	NaN
7373	603b77170a7217c72c0002e6	2.0	2021-02-28 10:57:27.000	2021-02-28 10:57:27.000	NaT	2021-02-28 10:57:28.000	NaT	2020-08-17	25.0	34.959999	B076FJ92M4	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	22.97	22.97	NaN	0	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	22.97	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	None	NaN	None	None	NaN	None	None	NaN	22.97	None	603b77170a7217c72c0002e6_1	2.0	0.0	NaN	NaN
7374	603b77170a7217c72c0002e6	2.0	2021-02-28 10:57:27.000	2021-02-28 10:57:27.000	NaT	2021-02-28 10:57:28.000	NaT	2020-08-17	25.0	34.959999	B07BRRLSVC	thindust summer face mask - sun protection neck gaiter for outdooractivities	11.99	11.99	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	11.99	thindust summer face mask - sun protection neck gaiter for outdooractivities	None	NaN	None	None	NaN	None	None	NaN	11.99	None	603b77170a7217c72c0002e6_2	2.0	0.0	NaN	NaN
7375	603bdbe10a7217c72c00033e	2.0	2021-02-28 18:07:29.000	2021-02-28 18:07:29.000	NaT	2021-02-28 18:07:30.000	NaT	2020-08-17	25.0	34.959999	B076FJ92M4	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	22.97	22.97	NaN	0	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	22.97	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	None	NaN	None	None	NaN	None	None	NaN	22.97	None	603bdbe10a7217c72c00033e_1	2.0	0.0	NaN	NaN
7376	603bdbe10a7217c72c00033e	2.0	2021-02-28 18:07:29.000	2021-02-28 18:07:29.000	NaT	2021-02-28 18:07:30.000	NaT	2020-08-17	25.0	34.959999	B07BRRLSVC	thindust summer face mask - sun protection neck gaiter for outdooractivities	11.99	11.99	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	11.99	thindust summer face mask - sun protection neck gaiter for outdooractivities	None	NaN	None	None	NaN	None	None	NaN	11.99	None	603bdbe10a7217c72c00033e_2	2.0	0.0	NaN	NaN
7377	603c4fea0a7217c72c000389	NaN	2021-03-01 02:22:34.962	2021-03-01 02:22:34.962	NaT	2021-03-01 02:22:34.962	NaT	NaT	NaN	NaN	None	None	None	NaN	NaN	None	NaN	NaN	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	NaN	None	None	NaN	None	None	603c4fea0a7217c72c000389_1	NaN	NaN	NaN	NaN
7378	603ca44a0a720fde100003d0	NaN	2021-03-01 08:22:34.244	2021-03-01 08:22:34.244	NaT	2021-03-01 08:22:34.244	NaT	NaT	NaN	NaN	None	None	None	NaN	NaN	None	NaN	NaN	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	NaN	None	None	NaN	None	None	NaN	None	None	603ca44a0a720fde100003d0_1	NaN	NaN	NaN	NaN
7379	603d59e70a7217c72c00045f	2.0	2021-03-01 21:17:27.000	2021-03-01 21:17:27.000	NaT	2021-03-01 21:17:28.000	NaT	2020-08-17	25.0	34.959999	B076FJ92M4	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	22.97	22.97	NaN	0	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	22.97	mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white	None	NaN	None	None	NaN	None	None	NaN	22.97	None	603d59e70a7217c72c00045f_1	2.0	0.0	NaN	NaN
7380	603d59e70a7217c72c00045f	2.0	2021-03-01 21:17:27.000	2021-03-01 21:17:27.000	NaT	2021-03-01 21:17:28.000	NaT	2020-08-17	25.0	34.959999	B07BRRLSVC	thindust summer face mask - sun protection neck gaiter for outdooractivities	11.99	11.99	NaN	1	NaN	1.0	None	NaN	None	NaN	None	None	None	None	None	None	None	None	None	None	11.99	thindust summer face mask - sun protection neck gaiter for outdooractivities	None	NaN	None	None	NaN	None	None	NaN	11.99	None	603d59e70a7217c72c00045f_2	2.0	0.0	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)